using System;
using System.Data;
using System.Collections.Generic;
namespace eTMS.DAO{
	/********************************BEGIN MonThiDAO****************************************/
	///<summary>
	/// <para>Author: Auto generated class by CSharp Code Generator v2.0</para>
	/// <para>Date:04/09/2010 42:05:29</para>
	/// <para>Class Name: MonThiDAO</para>
	/// <para>Description: Class access to table MonThi in database. Class for coder code here</para>
	///</summary>

	
	public partial class MonThiDAO{
        public DataSet SelectAllDSWithMonHoc(int KyThi_ID)
        {
            IDbCommand cmd = this.CreateCommand();
            cmd.CommandText = @"SELECT        MonThi.LanThi, MonThi.MonHoc_ID, MonThi.MonThi_ID, MonThi.KyThi_ID, MonThi.NgayThi, MonThi.TrangThai, MonHoc.MaMonHoc, MonHoc.TenMonHoc, 
                                            MonHoc.SoHocPhan, BoMon.MaBoMon, BoMon.TenBoMon, Khoa.MaKhoa, Khoa.TenKhoa
                                FROM            MonHoc INNER JOIN
                                                         MonThi ON MonHoc.MonHoc_ID = MonThi.MonHoc_ID INNER JOIN
                                                         BoMon ON MonHoc.BoMon_ID = BoMon.BoMon_ID INNER JOIN
                                                         Khoa ON BoMon.Khoa_ID = Khoa.Khoa_ID
                                WHERE MonThi.KyThi_ID="+KyThi_ID.ToString();
            return this.SelectDS(cmd);
        }

	}
	/*****************************************************************************************************/
	/**********************************END MonThiDAO*****************************************/
	/*****************************************************************************************************/
}

